﻿--HEADER Analytics.State.IdeaId

DROP TABLE [Analytics].[State]
GO

CREATE TABLE [Analytics].[State](
	[FundBookEntityId] [int] NOT NULL,
	[ProcessorCode] [tinyint] NOT NULL,
	[IdeaId] [uniqueidentifier] NOT NULL,
	[BuilderState] [varbinary](max) NOT NULL,
	CONSTRAINT [PK_State] PRIMARY KEY CLUSTERED 
	(
		[FundBookEntityId],
		[ProcessorCode],
		[IdeaId]
	)
)

GO

DELETE FROM UDS.LastProcessedAction